﻿CREATE PROCEDURE BILL.InsertBillItem
	@billId INT = NULL,
	@productId INT = NULL,
    @count INT = NULL,
	@price FLOAT = NULL,

	@checkValidation BIT = NULL
AS
BEGIN
	DECLARE @id INT

	EXEC BILL.InsertBillItemInternal
		@billId = @billId,
		@productId = @productId,
		@count = @count,
		@price = @price,
		@id = @id OUTPUT,
		@checkValidation = @checkValidation

	SELECT Id = @id
END

GO
GRANT EXECUTE
    ON OBJECT::BILL.InsertBillItem TO [BillingAdmin]
    AS [dbo];